package com.atguigu.tingshu.album.mapper;

import com.atguigu.tingshu.model.album.TrackInfo;
import com.atguigu.tingshu.query.album.TrackInfoQuery;
import com.atguigu.tingshu.vo.album.AlbumTrackListVo;
import com.atguigu.tingshu.vo.album.TrackListVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface TrackInfoMapper extends BaseMapper<TrackInfo> {


    IPage<TrackListVo> selectUserTrackPage(Page<TrackListVo> listVoPage,@Param("vo") TrackInfoQuery trackInfoQuery);
    @Update(" update track_info set order_num = order_num - 1 where album_id=#{albumId} and order_num > #{orderNum} and is_deleted = 0")
    void updateOrderNum(@Param("albumId") Long albumId,@Param("orderNum") Integer orderNum );

    @Select("select ti.id track_id,\n" +
            "       ti.track_title,\n" +
            "       ti.media_duration,\n" +
            "       ti.order_num,\n" +
            "       ti.create_time,\n" +
            "       MAX(IF(ts.stat_type = '0701', ts.stat_num, 0)) as playStatNum,\n" +
            "       MAX(IF(ts.stat_type = '0704', ts.stat_num, 0)) as commentStatNum\n" +
            "from track_info ti\n" +
            "         inner join track_stat ts on ti.id = ts.track_id\n" +
            "where ti.album_id = #{albumId}\n" +
            "  and ti.is_deleted = 0\n" +
            "group by ti.id")
    IPage<AlbumTrackListVo> selectAlbumInfoPage(Page<AlbumTrackListVo> pageParam, Long albumId);

    @Update("update track_stat\n" +
            "        set stat_num = stat_num + #{count}\n" +
            "where track_id = #{trackId} and stat_type = #{statType} and is_deleted = 0")
    void updateStat(@Param("trackId") Long trackId,@Param("statType") String statType,@Param("count") Integer count);
}
